Note The first row of data might be the first or second row in the external data range, depending on whether the first row contains headers.
Note If the external data range expands when you refresh, Microsoft Excel copies only those formulas that are immediately adjacent to or within the external data range.